<?php

use Illuminate\Database\Migrations\Migration;

class CreateUserUsrTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('User_Usr', function($table)
	    {
	        $table->increments('usr_code');
	        $table->string('usr_name', 30);
	        $table->string('usr_rifci', 10)->unique();
	        $table->string('usr_cellphone', 11)->nullable();
	        $table->boolean('usr_active');
	        $table->smallInteger('usr_status');
	        $table->timestamps();
	    });
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('User_Usr');
	}

}